Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 2680040 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 347.6 MiB |
| Average record size in memory | 136.0 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 3 |
geo_country has a high cardinality: 220 distinct values | High cardinality |
event_timestamp has a high cardinality: 1722186 distinct values | High cardinality |
mission_difficulty is highly correlated with mission_stars_collected and 1 other fields | High correlation |
mission_stars_collected is highly correlated with mission_difficulty and 4 other fields | High correlation |
day_auto_increment is highly correlated with days_played_in_month | High correlation |
lifetime_played_runs is highly correlated with mission_stars_collected and 3 other fields | High correlation |
max_run_distance is highly correlated with mission_stars_collected and 2 other fields | High correlation |
total_purchases_virtual is highly correlated with virtual_currency_balance | High correlation |
total_ads_watched is highly correlated with mission_stars_collected and 2 other fields | High correlation |
days_played_in_month is highly correlated with day_auto_increment | High correlation |
virtual_currency_balance is highly correlated with total_purchases_virtual | High correlation |
mission_played is highly correlated with mission_difficulty and 4 other fields | High correlation |
mission_difficulty is highly correlated with mission_played | High correlation |
mission_stars_collected is highly correlated with mission_played | High correlation |
day_auto_increment is highly correlated with days_played_in_month | High correlation |
lifetime_played_runs is highly correlated with mission_played | High correlation |
max_run_distance is highly correlated with mission_played | High correlation |
days_played_in_month is highly correlated with day_auto_increment | High correlation |
mission_played is highly correlated with mission_difficulty and 3 other fields | High correlation |
mission_stars_collected is highly correlated with lifetime_played_runs and 1 other fields | High correlation |
day_auto_increment is highly correlated with days_played_in_month | High correlation |
lifetime_played_runs is highly correlated with mission_stars_collected and 1 other fields | High correlation |
days_played_in_month is highly correlated with day_auto_increment | High correlation |
mission_played is highly correlated with mission_stars_collected and 1 other fields | High correlation |
mission_id is highly correlated with mission_played | High correlation |
mission_difficulty is highly correlated with mission_played | High correlation |
day_auto_increment is highly correlated with days_played_in_month | High correlation |
max_run_distance is highly correlated with total_ads_watched | High correlation |
total_ads_watched is highly correlated with max_run_distance | High correlation |
days_played_in_month is highly correlated with day_auto_increment | High correlation |
mission_played is highly correlated with mission_id and 1 other fields | High correlation |
mission_stars_collected is highly skewed (γ1 = 158.6920513) | Skewed |
total_purchases_real is highly skewed (γ1 = 67.63920479) | Skewed |
virtual_currency_balance is highly skewed (γ1 = 78.74891214) | Skewed |
event_timestamp is uniformly distributed | Uniform |
target_max_day_played has 225886 (8.4%) zeros | Zeros |
day_auto_increment has 1683097 (62.8%) zeros | Zeros |
total_purchases_virtual has 1318046 (49.2%) zeros | Zeros |
total_ads_watched has 1395498 (52.1%) zeros | Zeros |
total_purchases_real has 2665246 (99.4%) zeros | Zeros |
days_played_in_month has 1817797 (67.8%) zeros | Zeros |
Reproduction
| Analysis started | 2022-05-25 15:23:28.406530 |
|---|---|
| Analysis finished | 2022-05-25 15:29:47.621821 |
| Duration | 6 minutes and 19.22 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
df_index
Real number (ℝ≥0)
| Distinct | 268662 |
|---|---|
| Distinct (%) | 10.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 151370.7859 |
| Minimum | 0 |
|---|---|
| Maximum | 290201 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13639 |
| Q1 | 86348.75 |
| median | 154225 |
| Q3 | 222213 |
| 95-th percentile | 276615 |
| Maximum | 290201 |
| Range | 290201 |
| Interquartile range (IQR) | 135864.25 |
Descriptive statistics
| Standard deviation | 82835.14281 |
|---|---|
| Coefficient of variation (CV) | 0.5472333538 |
| Kurtosis | -1.096503108 |
| Mean | 151370.7859 |
| Median Absolute Deviation (MAD) | 67932 |
| Skewness | -0.1304178715 |
| Sum | 4.056797609 × 1011 |
| Variance | 6861660884 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 78868 | 10 | < 0.1% |
| 274629 | 10 | < 0.1% |
| 250064 | 10 | < 0.1% |
| 87313 | 10 | < 0.1% |
| 155234 | 10 | < 0.1% |
| 248571 | 10 | < 0.1% |
| 145527 | 10 | < 0.1% |
| 219475 | 10 | < 0.1% |
| 250635 | 10 | < 0.1% |
| 183756 | 10 | < 0.1% |
| Other values (268652) | 2679940 |
| Value | Count | Frequency (%) |
| 0 | 10 | |
| 1 | 10 | |
| 2 | 10 | |
| 3 | 10 | |
| 4 | 10 | |
| 5 | 10 | |
| 6 | 10 | |
| 7 | 10 | |
| 8 | 10 | |
| 9 | 10 |
| Value | Count | Frequency (%) |
| 290201 | 10 | |
| 290200 | 10 | |
| 290199 | 10 | |
| 290198 | 10 | |
| 290197 | 10 | |
| 290196 | 10 | |
| 290195 | 10 | |
| 290194 | 10 | |
| 290193 | 10 | |
| 290192 | 10 |
user_pseudo_id
Real number (ℝ≥0)
| Distinct | 268662 |
|---|---|
| Distinct (%) | 10.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49983770.56 |
| Minimum | 794 |
|---|---|
| Maximum | 99999617 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 794 |
|---|---|
| 5-th percentile | 5015829 |
| Q1 | 24965731 |
| median | 50053499 |
| Q3 | 74913508 |
| 95-th percentile | 94929788 |
| Maximum | 99999617 |
| Range | 99998823 |
| Interquartile range (IQR) | 49947777 |
Descriptive statistics
| Standard deviation | 28862679.47 |
|---|---|
| Coefficient of variation (CV) | 0.5774410204 |
| Kurtosis | -1.201938662 |
| Mean | 49983770.56 |
| Median Absolute Deviation (MAD) | 24976003 |
| Skewness | -0.002183217932 |
| Sum | 1.339585044 × 1014 |
| Variance | 8.330542664 × 1014 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 794 | 10 | < 0.1% |
| 66566738 | 10 | < 0.1% |
| 66566798 | 10 | < 0.1% |
| 66567847 | 10 | < 0.1% |
| 66567945 | 10 | < 0.1% |
| 66568676 | 10 | < 0.1% |
| 66568770 | 10 | < 0.1% |
| 66568994 | 10 | < 0.1% |
| 66569413 | 10 | < 0.1% |
| 66569946 | 10 | < 0.1% |
| Other values (268652) | 2679940 |
| Value | Count | Frequency (%) |
| 794 | 10 | |
| 943 | 10 | |
| 1030 | 10 | |
| 2511 | 10 | |
| 2723 | 10 | |
| 2991 | 10 | |
| 3194 | 10 | |
| 3842 | 10 | |
| 5480 | 10 | |
| 6213 | 10 |
| Value | Count | Frequency (%) |
| 99999617 | 10 | |
| 99999432 | 10 | |
| 99999334 | 10 | |
| 99998701 | 10 | |
| 99998367 | 10 | |
| 99998240 | 10 | |
| 99997868 | 10 | |
| 99997620 | 10 | |
| 99997310 | 10 | |
| 99996452 | 10 |
| Distinct | 111 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.445219474 |
| Minimum | 0 |
|---|---|
| Maximum | 184 |
| Zeros | 225886 |
| Zeros (%) | 8.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 4 |
| Q3 | 8 |
| 95-th percentile | 21 |
| Maximum | 184 |
| Range | 184 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 7.95990996 |
|---|---|
| Coefficient of variation (CV) | 1.235009916 |
| Kurtosis | 21.18527688 |
| Mean | 6.445219474 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 3.559841456 |
| Sum | 17273446 |
| Variance | 63.36016657 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 347321 | |
| 2 | 339491 | |
| 3 | 293519 | |
| 4 | 241931 | |
| 0 | 225886 | |
| 5 | 199386 | 7.4% |
| 6 | 164302 | 6.1% |
| 7 | 132438 | 4.9% |
| 8 | 109220 | 4.1% |
| 9 | 90444 | 3.4% |
| Other values (101) | 536102 |
| Value | Count | Frequency (%) |
| 0 | 225886 | |
| 1 | 347321 | |
| 2 | 339491 | |
| 3 | 293519 | |
| 4 | 241931 | |
| 5 | 199386 | |
| 6 | 164302 | |
| 7 | 132438 | 4.9% |
| 8 | 109220 | 4.1% |
| 9 | 90444 | 3.4% |
| Value | Count | Frequency (%) |
| 184 | 10 | |
| 159 | 10 | |
| 151 | 10 | |
| 141 | 10 | |
| 128 | 10 | |
| 107 | 10 | |
| 106 | 20 | |
| 103 | 20 | |
| 102 | 20 | |
| 101 | 20 |
| Distinct | 223 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59.2186986 |
| Minimum | 1 |
|---|---|
| Maximum | 372 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 11 |
| median | 66 |
| Q3 | 113 |
| 95-th percentile | 115 |
| Maximum | 372 |
| Range | 371 |
| Interquartile range (IQR) | 102 |
Descriptive statistics
| Standard deviation | 49.15026032 |
|---|---|
| Coefficient of variation (CV) | 0.829978731 |
| Kurtosis | -1.797156115 |
| Mean | 59.2186986 |
| Median Absolute Deviation (MAD) | 48 |
| Skewness | 0.04218996138 |
| Sum | 158708481 |
| Variance | 2415.748089 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 115 | 278002 | |
| 3 | 277925 | |
| 86 | 269273 | |
| 114 | 259776 | |
| 19 | 259288 | |
| 11 | 258687 | |
| 113 | 255342 | |
| 109 | 254863 | |
| 6 | 248149 | |
| 12 | 187138 | |
| Other values (213) | 131597 |
| Value | Count | Frequency (%) |
| 1 | 5 | < 0.1% |
| 3 | 277925 | |
| 5 | 90 | < 0.1% |
| 6 | 248149 | |
| 7 | 602 | < 0.1% |
| 8 | 20 | < 0.1% |
| 9 | 100 | < 0.1% |
| 10 | 77412 | 2.9% |
| 11 | 258687 | |
| 12 | 187138 |
| Value | Count | Frequency (%) |
| 372 | 2 | < 0.1% |
| 371 | 1 | < 0.1% |
| 370 | 4 | |
| 369 | 6 | |
| 367 | 1 | < 0.1% |
| 366 | 3 | < 0.1% |
| 364 | 5 | |
| 363 | 8 | |
| 361 | 1 | < 0.1% |
| 360 | 7 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.4 MiB |
| 1.0 | |
|---|---|
| 2.0 | |
| 3.0 | 20 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 1933528 | |
| 2.0 | 746492 | 27.9% |
| 3.0 | 20 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1.0 | 1933528 | |
| 2.0 | 746492 | 27.9% |
| 3.0 | 20 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 78 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.50493724 |
| Minimum | 0 |
|---|---|
| Maximum | 1772 |
| Zeros | 5959 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 7 |
| Q3 | 11 |
| 95-th percentile | 14 |
| Maximum | 1772 |
| Range | 1772 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 5.042256999 |
|---|---|
| Coefficient of variation (CV) | 0.6718586495 |
| Kurtosis | 55099.91193 |
| Mean | 7.50493724 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 158.6920513 |
| Sum | 20113532 |
| Variance | 25.42435564 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 483211 | |
| 6 | 276592 | |
| 8 | 259368 | |
| 4 | 232340 | |
| 7 | 214456 | |
| 5 | 206933 | |
| 11 | 192766 | 7.2% |
| 14 | 176941 | 6.6% |
| 9 | 175642 | 6.6% |
| 12 | 130291 | 4.9% |
| Other values (68) | 331500 |
| Value | Count | Frequency (%) |
| 0 | 5959 | 0.2% |
| 1 | 16357 | 0.6% |
| 2 | 6960 | 0.3% |
| 3 | 483211 | |
| 4 | 232340 | |
| 5 | 206933 | |
| 6 | 276592 | |
| 7 | 214456 | |
| 8 | 259368 | |
| 9 | 175642 | 6.6% |
| Value | Count | Frequency (%) |
| 1772 | 1 | |
| 1769 | 2 | |
| 1768 | 1 | |
| 1766 | 1 | |
| 1765 | 1 | |
| 1761 | 2 | |
| 1760 | 1 | |
| 1759 | 1 | |
| 280 | 1 | |
| 277 | 1 |
day_auto_increment
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 50 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6727026462 |
| Minimum | 0 |
|---|---|
| Maximum | 58 |
| Zeros | 1683097 |
| Zeros (%) | 62.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 58 |
| Range | 58 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.283770145 |
|---|---|
| Coefficient of variation (CV) | 1.908376832 |
| Kurtosis | 44.35873336 |
| Mean | 0.6727026462 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.363842316 |
| Sum | 1802870 |
| Variance | 1.648065786 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1683097 | |
| 1 | 611625 | 22.8% |
| 2 | 203464 | 7.6% |
| 3 | 86629 | 3.2% |
| 4 | 41820 | 1.6% |
| 5 | 22351 | 0.8% |
| 6 | 11932 | 0.4% |
| 7 | 6907 | 0.3% |
| 8 | 4131 | 0.2% |
| 9 | 2660 | 0.1% |
| Other values (40) | 5424 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 1683097 | |
| 1 | 611625 | 22.8% |
| 2 | 203464 | 7.6% |
| 3 | 86629 | 3.2% |
| 4 | 41820 | 1.6% |
| 5 | 22351 | 0.8% |
| 6 | 11932 | 0.4% |
| 7 | 6907 | 0.3% |
| 8 | 4131 | 0.2% |
| 9 | 2660 | 0.1% |
| Value | Count | Frequency (%) |
| 58 | 1 | < 0.1% |
| 52 | 1 | < 0.1% |
| 51 | 1 | < 0.1% |
| 50 | 6 | |
| 46 | 1 | < 0.1% |
| 45 | 1 | < 0.1% |
| 44 | 1 | < 0.1% |
| 42 | 1 | < 0.1% |
| 41 | 2 | < 0.1% |
| 40 | 2 | < 0.1% |
| Distinct | 285 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.16777772 |
| Minimum | 0 |
|---|---|
| Maximum | 632 |
| Zeros | 5769 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 8 |
| 95-th percentile | 19 |
| Maximum | 632 |
| Range | 632 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 7.930375263 |
|---|---|
| Coefficient of variation (CV) | 1.28577514 |
| Kurtosis | 184.8159278 |
| Mean | 6.16777772 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 7.62512371 |
| Sum | 16529891 |
| Variance | 62.8908518 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 542669 | |
| 1 | 417848 | |
| 3 | 328215 | |
| 4 | 237218 | |
| 5 | 190534 | 7.1% |
| 6 | 158236 | 5.9% |
| 7 | 128681 | 4.8% |
| 8 | 105395 | 3.9% |
| 9 | 84058 | 3.1% |
| 10 | 68743 | 2.6% |
| Other values (275) | 418443 |
| Value | Count | Frequency (%) |
| 0 | 5769 | 0.2% |
| 1 | 417848 | |
| 2 | 542669 | |
| 3 | 328215 | |
| 4 | 237218 | |
| 5 | 190534 | 7.1% |
| 6 | 158236 | 5.9% |
| 7 | 128681 | 4.8% |
| 8 | 105395 | 3.9% |
| 9 | 84058 | 3.1% |
| Value | Count | Frequency (%) |
| 632 | 1 | < 0.1% |
| 454 | 10 | |
| 408 | 1 | < 0.1% |
| 406 | 1 | < 0.1% |
| 403 | 1 | < 0.1% |
| 402 | 3 | < 0.1% |
| 389 | 1 | < 0.1% |
| 387 | 2 | < 0.1% |
| 386 | 2 | < 0.1% |
| 385 | 3 | < 0.1% |
| Distinct | 9672 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2385.666054 |
| Minimum | 0 |
|---|---|
| Maximum | 28463 |
| Zeros | 5795 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1140 |
| Q1 | 1501 |
| median | 2134 |
| Q3 | 2905 |
| 95-th percentile | 4628 |
| Maximum | 28463 |
| Range | 28463 |
| Interquartile range (IQR) | 1404 |
Descriptive statistics
| Standard deviation | 1189.046409 |
|---|---|
| Coefficient of variation (CV) | 0.4984127629 |
| Kurtosis | 7.483256069 |
| Mean | 2385.666054 |
| Median Absolute Deviation (MAD) | 677 |
| Skewness | 1.876945208 |
| Sum | 6393680451 |
| Variance | 1413831.364 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5795 | 0.2% |
| 1224 | 1710 | 0.1% |
| 1145 | 1707 | 0.1% |
| 1160 | 1699 | 0.1% |
| 1167 | 1696 | 0.1% |
| 1201 | 1694 | 0.1% |
| 1311 | 1691 | 0.1% |
| 1234 | 1682 | 0.1% |
| 1181 | 1679 | 0.1% |
| 1312 | 1673 | 0.1% |
| Other values (9662) | 2659014 |
| Value | Count | Frequency (%) |
| 0 | 5795 | |
| 103 | 1 | < 0.1% |
| 104 | 3 | < 0.1% |
| 108 | 2 | < 0.1% |
| 113 | 2 | < 0.1% |
| 117 | 2 | < 0.1% |
| 118 | 3 | < 0.1% |
| 119 | 1 | < 0.1% |
| 122 | 2 | < 0.1% |
| 123 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 28463 | 1 | < 0.1% |
| 24648 | 10 | |
| 22371 | 4 | < 0.1% |
| 21744 | 1 | < 0.1% |
| 20807 | 4 | < 0.1% |
| 20153 | 2 | < 0.1% |
| 20053 | 3 | < 0.1% |
| 19962 | 1 | < 0.1% |
| 18915 | 2 | < 0.1% |
| 18876 | 3 | < 0.1% |
| Distinct | 5242 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33653.92234 |
| Minimum | 0 |
|---|---|
| Maximum | 8099500 |
| Zeros | 1318046 |
| Zeros (%) | 49.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 500 |
| Q3 | 4000 |
| 95-th percentile | 11000 |
| Maximum | 8099500 |
| Range | 8099500 |
| Interquartile range (IQR) | 4000 |
Descriptive statistics
| Standard deviation | 368409.9334 |
|---|---|
| Coefficient of variation (CV) | 10.94701324 |
| Kurtosis | 165.7536268 |
| Mean | 33653.92234 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 12.64392757 |
| Sum | 9.019385802 × 1010 |
| Variance | 1.35725879 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1318046 | |
| 1500 | 314269 | 11.7% |
| 4000 | 127917 | 4.8% |
| 5500 | 87067 | 3.2% |
| 3000 | 80291 | 3.0% |
| 500 | 65517 | 2.4% |
| 4500 | 64209 | 2.4% |
| 6000 | 58088 | 2.2% |
| 1000 | 48538 | 1.8% |
| 2000 | 45424 | 1.7% |
| Other values (5232) | 470674 | 17.6% |
| Value | Count | Frequency (%) |
| 0 | 1318046 | |
| 500 | 65517 | 2.4% |
| 1000 | 48538 | 1.8% |
| 1500 | 314269 | 11.7% |
| 2000 | 45424 | 1.7% |
| 2500 | 37633 | 1.4% |
| 3000 | 80291 | 3.0% |
| 3500 | 23910 | 0.9% |
| 4000 | 127917 | 4.8% |
| 4500 | 64209 | 2.4% |
| Value | Count | Frequency (%) |
| 8099500 | 1 | |
| 8098500 | 1 | |
| 8081000 | 1 | |
| 8012000 | 1 | |
| 8009000 | 1 | |
| 7928000 | 1 | |
| 7927000 | 1 | |
| 7922500 | 1 | |
| 7921500 | 1 | |
| 7920500 | 1 |
| Distinct | 170 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.431097297 |
| Minimum | 0 |
|---|---|
| Maximum | 239 |
| Zeros | 1395498 |
| Zeros (%) | 52.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 11 |
| Maximum | 239 |
| Range | 239 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 4.999152451 |
|---|---|
| Coefficient of variation (CV) | 2.056335819 |
| Kurtosis | 82.71175618 |
| Mean | 2.431097297 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.938305411 |
| Sum | 6515438 |
| Variance | 24.99152523 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1395498 | |
| 1 | 319677 | 11.9% |
| 2 | 217009 | 8.1% |
| 3 | 161255 | 6.0% |
| 4 | 122364 | 4.6% |
| 5 | 93120 | 3.5% |
| 6 | 70813 | 2.6% |
| 7 | 54818 | 2.0% |
| 8 | 42215 | 1.6% |
| 9 | 33258 | 1.2% |
| Other values (160) | 170013 | 6.3% |
| Value | Count | Frequency (%) |
| 0 | 1395498 | |
| 1 | 319677 | 11.9% |
| 2 | 217009 | 8.1% |
| 3 | 161255 | 6.0% |
| 4 | 122364 | 4.6% |
| 5 | 93120 | 3.5% |
| 6 | 70813 | 2.6% |
| 7 | 54818 | 2.0% |
| 8 | 42215 | 1.6% |
| 9 | 33258 | 1.2% |
| Value | Count | Frequency (%) |
| 239 | 1 | < 0.1% |
| 235 | 1 | < 0.1% |
| 230 | 1 | < 0.1% |
| 225 | 1 | < 0.1% |
| 220 | 1 | < 0.1% |
| 217 | 1 | < 0.1% |
| 205 | 1 | < 0.1% |
| 202 | 1 | < 0.1% |
| 201 | 3 | |
| 198 | 1 | < 0.1% |
| Distinct | 605 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.02279883509 |
| Minimum | 0 |
|---|---|
| Maximum | 133.93 |
| Zeros | 2665246 |
| Zeros (%) | 99.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 133.93 |
| Range | 133.93 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6211283974 |
|---|---|
| Coefficient of variation (CV) | 27.24386553 |
| Kurtosis | 6996.434685 |
| Mean | 0.02279883509 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 67.63920479 |
| Sum | 61101.79 |
| Variance | 0.3858004861 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2665246 | |
| 1.99 | 2135 | 0.1% |
| 0.48 | 1147 | < 0.1% |
| 0.49 | 813 | < 0.1% |
| 4.98 | 661 | < 0.1% |
| 0.99 | 598 | < 0.1% |
| 0.37 | 440 | < 0.1% |
| 2.99 | 420 | < 0.1% |
| 3.99 | 356 | < 0.1% |
| 0.11 | 261 | < 0.1% |
| Other values (595) | 7963 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 2665246 | |
| 0.11 | 261 | < 0.1% |
| 0.13 | 5 | < 0.1% |
| 0.14 | 25 | < 0.1% |
| 0.22 | 71 | < 0.1% |
| 0.27 | 2 | < 0.1% |
| 0.3 | 1 | < 0.1% |
| 0.31 | 48 | < 0.1% |
| 0.32 | 29 | < 0.1% |
| 0.33 | 155 | < 0.1% |
| Value | Count | Frequency (%) |
| 133.93 | 1 | < 0.1% |
| 96.69 | 4 | < 0.1% |
| 94.7 | 1 | < 0.1% |
| 92.53 | 3 | < 0.1% |
| 79.91 | 6 | |
| 78.76 | 4 | < 0.1% |
| 73.94 | 3 | < 0.1% |
| 73.93 | 10 | |
| 67.83 | 10 | |
| 64.97 | 6 |
| Distinct | 220 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.4 MiB |
| United States | |
|---|---|
| Mexico | |
| Brazil | 131641 |
| France | 112166 |
| Russia | 107711 |
| Other values (215) |
Length
| Max length | 24 |
|---|---|
| Median length | 7 |
| Mean length | 8.140946404 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | India |
|---|---|
| 2nd row | India |
| 3rd row | India |
| 4th row | India |
| 5th row | India |
Common Values
| Value | Count | Frequency (%) |
| United States | 449106 | |
| Mexico | 341118 | 12.7% |
| Brazil | 131641 | 4.9% |
| France | 112166 | 4.2% |
| Russia | 107711 | 4.0% |
| India | 96080 | 3.6% |
| Germany | 91052 | 3.4% |
| Turkey | 82896 | 3.1% |
| United Kingdom | 82838 | 3.1% |
| Colombia | 68028 | 2.5% |
| Other values (210) | 1117404 |
Length
| Value | Count | Frequency (%) |
| united | 538218 | |
| states | 449106 | 13.5% |
| mexico | 341118 | 10.3% |
| brazil | 131641 | 4.0% |
| france | 112166 | 3.4% |
| russia | 107711 | 3.2% |
| india | 96080 | 2.9% |
| germany | 91052 | 2.7% |
| turkey | 82896 | 2.5% |
| kingdom | 82838 | 2.5% |
| Other values (249) | 1281760 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
days_played_in_month
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 26 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4930090596 |
| Minimum | 0 |
|---|---|
| Maximum | 25 |
| Zeros | 1817797 |
| Zeros (%) | 67.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 25 |
| Range | 25 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.9290332314 |
|---|---|
| Coefficient of variation (CV) | 1.884414116 |
| Kurtosis | 18.69182895 |
| Mean | 0.4930090596 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.227741826 |
| Sum | 1321284 |
| Variance | 0.863102745 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1817797 | |
| 1 | 592554 | 22.1% |
| 2 | 165924 | 6.2% |
| 3 | 59195 | 2.2% |
| 4 | 24085 | 0.9% |
| 5 | 10830 | 0.4% |
| 6 | 4801 | 0.2% |
| 7 | 2282 | 0.1% |
| 8 | 1160 | < 0.1% |
| 9 | 617 | < 0.1% |
| Other values (16) | 795 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1817797 | |
| 1 | 592554 | 22.1% |
| 2 | 165924 | 6.2% |
| 3 | 59195 | 2.2% |
| 4 | 24085 | 0.9% |
| 5 | 10830 | 0.4% |
| 6 | 4801 | 0.2% |
| 7 | 2282 | 0.1% |
| 8 | 1160 | < 0.1% |
| 9 | 617 | < 0.1% |
| Value | Count | Frequency (%) |
| 25 | 1 | < 0.1% |
| 24 | 3 | < 0.1% |
| 23 | 3 | < 0.1% |
| 22 | 2 | < 0.1% |
| 21 | 1 | < 0.1% |
| 20 | 5 | < 0.1% |
| 19 | 3 | < 0.1% |
| 18 | 7 | |
| 17 | 13 | |
| 16 | 11 |
| Distinct | 46605 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 328729.3675 |
| Minimum | 0 |
|---|---|
| Maximum | 2146000000 |
| Zeros | 200 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 605 |
| Q1 | 4017 |
| median | 5648 |
| Q3 | 6987 |
| 95-th percentile | 11442 |
| Maximum | 2146000000 |
| Range | 2146000000 |
| Interquartile range (IQR) | 2970 |
Descriptive statistics
| Standard deviation | 16969510.17 |
|---|---|
| Coefficient of variation (CV) | 51.62152166 |
| Kurtosis | 7010.745718 |
| Mean | 328729.3675 |
| Median Absolute Deviation (MAD) | 1523 |
| Skewness | 78.74891214 |
| Sum | 8.810078542 × 1011 |
| Variance | 2.879642753 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5579 | 1858 | 0.1% |
| 5570 | 1841 | 0.1% |
| 5554 | 1827 | 0.1% |
| 5545 | 1801 | 0.1% |
| 5571 | 1789 | 0.1% |
| 5574 | 1788 | 0.1% |
| 5559 | 1767 | 0.1% |
| 5562 | 1766 | 0.1% |
| 5566 | 1765 | 0.1% |
| 5548 | 1755 | 0.1% |
| Other values (46595) | 2662083 |
| Value | Count | Frequency (%) |
| 0 | 200 | |
| 1 | 166 | |
| 2 | 183 | |
| 3 | 173 | |
| 4 | 175 | |
| 5 | 181 | |
| 6 | 156 | |
| 7 | 178 | |
| 8 | 162 | |
| 9 | 154 |
| Value | Count | Frequency (%) |
| 2146000000 | 9 | |
| 2000000000 | 4 | < 0.1% |
| 1999990000 | 1 | < 0.1% |
| 1997650000 | 2 | < 0.1% |
| 1996150000 | 3 | < 0.1% |
| 1996140000 | 5 | |
| 1995620000 | 10 | |
| 1995250000 | 10 | |
| 1994110000 | 5 | |
| 1994100000 | 8 |
| Distinct | 1722186 |
|---|---|
| Distinct (%) | 64.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.4 MiB |
| 03-02-2022 15:34:43 | 10 |
|---|---|
| 22-02-2022 20:34:24 | 10 |
| 04-02-2022 23:45:10 | 9 |
| 12-02-2022 18:03:09 | 9 |
| 27-02-2022 16:13:14 | 9 |
| Other values (1722181) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1062528 ? |
|---|---|
| Unique (%) | 39.6% |
Sample
| 1st row | 19-02-2022 18:47:18 |
|---|---|
| 2nd row | 19-02-2022 18:47:52 |
| 3rd row | 19-02-2022 18:47:57 |
| 4th row | 19-02-2022 18:51:30 |
| 5th row | 19-02-2022 18:53:40 |
Common Values
| Value | Count | Frequency (%) |
| 03-02-2022 15:34:43 | 10 | < 0.1% |
| 22-02-2022 20:34:24 | 10 | < 0.1% |
| 04-02-2022 23:45:10 | 9 | < 0.1% |
| 12-02-2022 18:03:09 | 9 | < 0.1% |
| 27-02-2022 16:13:14 | 9 | < 0.1% |
| 11-02-2022 16:00:17 | 9 | < 0.1% |
| 10-02-2022 18:03:11 | 9 | < 0.1% |
| 22-02-2022 17:11:11 | 9 | < 0.1% |
| 27-02-2022 20:39:33 | 9 | < 0.1% |
| 10-02-2022 02:28:20 | 9 | < 0.1% |
| Other values (1722176) | 2679948 |
Length
| Value | Count | Frequency (%) |
| 27-02-2022 | 102729 | 1.9% |
| 26-02-2022 | 101032 | 1.9% |
| 20-02-2022 | 100948 | 1.9% |
| 25-02-2022 | 97505 | 1.8% |
| 19-02-2022 | 96787 | 1.8% |
| 22-02-2022 | 96127 | 1.8% |
| 21-02-2022 | 94737 | 1.8% |
| 13-02-2022 | 94730 | 1.8% |
| 06-02-2022 | 94083 | 1.8% |
| 12-02-2022 | 93916 | 1.8% |
| Other values (86499) | 4387486 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
mission_played
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.496324309 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.87192445 |
|---|---|
| Coefficient of variation (CV) | 0.522517284 |
| Kurtosis | -1.224021514 |
| Mean | 5.496324309 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.001494280985 |
| Sum | 14730369 |
| Variance | 8.247950045 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 268437 | |
| 2 | 268384 | |
| 3 | 268319 | |
| 4 | 268208 | |
| 5 | 268123 | |
| 6 | 268033 | |
| 7 | 267886 | |
| 8 | 267762 | |
| 9 | 267616 | |
| 10 | 267272 |
| Value | Count | Frequency (%) |
| 1 | 268437 | |
| 2 | 268384 | |
| 3 | 268319 | |
| 4 | 268208 | |
| 5 | 268123 | |
| 6 | 268033 | |
| 7 | 267886 | |
| 8 | 267762 | |
| 9 | 267616 | |
| 10 | 267272 |
| Value | Count | Frequency (%) |
| 10 | 267272 | |
| 9 | 267616 | |
| 8 | 267762 | |
| 7 | 267886 | |
| 6 | 268033 | |
| 5 | 268123 | |
| 4 | 268208 | |
| 3 | 268319 | |
| 2 | 268384 | |
| 1 | 268437 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | user_pseudo_id | target_max_day_played | mission_id | mission_difficulty | mission_stars_collected | day_auto_increment | lifetime_played_runs | max_run_distance | total_purchases_virtual | total_ads_watched | total_purchases_real | geo_country | days_played_in_month | virtual_currency_balance | event_timestamp | mission_played | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 78868 | 794 | 0 | 115 | 1.0 | 3.0 | 0.0 | 1.0 | 1183.0 | 0.0 | 0.0 | 0.0 | India | 0.0 | 5715.0 | 19-02-2022 18:47:18 | 1 |
| 1 | 78868 | 794 | 0 | 113 | 1.0 | 3.0 | 0.0 | 1.0 | 1183.0 | 0.0 | 0.0 | 0.0 | India | 0.0 | 5715.0 | 19-02-2022 18:47:52 | 2 |
| 2 | 78868 | 794 | 0 | 109 | 1.0 | 3.0 | 0.0 | 1.0 | 1183.0 | 0.0 | 0.0 | 0.0 | India | 0.0 | 5715.0 | 19-02-2022 18:47:57 | 3 |
| 3 | 78868 | 794 | 0 | 11 | 1.0 | 6.0 | 0.0 | 3.0 | 1695.0 | 0.0 | 2.0 | 0.0 | India | 0.0 | 6842.0 | 19-02-2022 18:51:30 | 4 |
| 4 | 78868 | 794 | 0 | 114 | 1.0 | 7.0 | 0.0 | 4.0 | 1695.0 | 0.0 | 3.0 | 0.0 | India | 0.0 | 7342.0 | 19-02-2022 18:53:40 | 5 |
| 5 | 78868 | 794 | 0 | 3 | 1.0 | 7.0 | 0.0 | 4.0 | 1695.0 | 0.0 | 3.0 | 0.0 | India | 0.0 | 7342.0 | 19-02-2022 18:54:10 | 6 |
| 6 | 78868 | 794 | 0 | 19 | 2.0 | 9.0 | 0.0 | 5.0 | 2104.0 | 0.0 | 5.0 | 0.0 | India | 0.0 | 8284.0 | 19-02-2022 18:59:12 | 7 |
| 7 | 78868 | 794 | 0 | 86 | 2.0 | 11.0 | 0.0 | 6.0 | 2104.0 | 0.0 | 6.0 | 0.0 | India | 0.0 | 8941.0 | 19-02-2022 19:00:13 | 8 |
| 8 | 78868 | 794 | 0 | 12 | 2.0 | 11.0 | 0.0 | 6.0 | 2104.0 | 0.0 | 6.0 | 0.0 | India | 0.0 | 8941.0 | 19-02-2022 19:00:20 | 9 |
| 9 | 78868 | 794 | 0 | 6 | 1.0 | 15.0 | 0.0 | 8.0 | 2104.0 | 6000.0 | 8.0 | 0.0 | India | 0.0 | 3849.0 | 20-02-2022 04:33:14 | 10 |
Last rows
| df_index | user_pseudo_id | target_max_day_played | mission_id | mission_difficulty | mission_stars_collected | day_auto_increment | lifetime_played_runs | max_run_distance | total_purchases_virtual | total_ads_watched | total_purchases_real | geo_country | days_played_in_month | virtual_currency_balance | event_timestamp | mission_played | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2680030 | 129581 | 99999617 | 2 | 113 | 1.0 | 3.0 | 1.0 | 1.0 | 1498.0 | 0.0 | 0.0 | 0.0 | Mexico | 1.0 | 5563.0 | 12-02-2022 14:58:38 | 1 |
| 2680031 | 129581 | 99999617 | 2 | 109 | 1.0 | 3.0 | 1.0 | 1.0 | 1498.0 | 0.0 | 0.0 | 0.0 | Mexico | 1.0 | 5563.0 | 12-02-2022 14:58:55 | 2 |
| 2680032 | 129581 | 99999617 | 2 | 3 | 1.0 | 5.0 | 1.0 | 2.0 | 1498.0 | 0.0 | 0.0 | 0.0 | Mexico | 1.0 | 5632.0 | 12-02-2022 15:00:37 | 3 |
| 2680033 | 129581 | 99999617 | 2 | 11 | 1.0 | 5.0 | 1.0 | 2.0 | 1498.0 | 0.0 | 0.0 | 0.0 | Mexico | 1.0 | 5632.0 | 12-02-2022 15:01:11 | 4 |
| 2680034 | 129581 | 99999617 | 2 | 114 | 1.0 | 7.0 | 1.0 | 3.0 | 1888.0 | 1500.0 | 0.0 | 0.0 | Mexico | 1.0 | 5368.0 | 12-02-2022 15:02:36 | 5 |
| 2680035 | 129581 | 99999617 | 2 | 115 | 1.0 | 7.0 | 1.0 | 3.0 | 1888.0 | 1500.0 | 0.0 | 0.0 | Mexico | 1.0 | 5368.0 | 12-02-2022 15:02:46 | 6 |
| 2680036 | 129581 | 99999617 | 2 | 6 | 1.0 | 7.0 | 1.0 | 3.0 | 1888.0 | 1500.0 | 0.0 | 0.0 | Mexico | 1.0 | 5368.0 | 12-02-2022 15:03:07 | 7 |
| 2680037 | 129581 | 99999617 | 2 | 19 | 2.0 | 10.0 | 1.0 | 4.0 | 1888.0 | 4000.0 | 0.0 | 0.0 | Mexico | 1.0 | 3616.0 | 12-02-2022 15:04:28 | 8 |
| 2680038 | 129581 | 99999617 | 2 | 12 | 2.0 | 12.0 | 1.0 | 5.0 | 1888.0 | 4000.0 | 0.0 | 0.0 | Mexico | 1.0 | 3616.0 | 12-02-2022 15:05:36 | 9 |
| 2680039 | 129581 | 99999617 | 2 | 86 | 2.0 | 14.0 | 1.0 | 6.0 | 1888.0 | 4000.0 | 0.0 | 0.0 | Mexico | 1.0 | 4463.0 | 12-02-2022 15:09:46 | 10 |